{
  "properties" : { },
  "id" : "6d7de5e801ea4634867dd15b62ccf872",
  "script" : null,
  "groupId" : "832da851b4034ccdb63b69855a4390ac",
  "name" : "查询源字段",
  "createTime" : 1727070869374,
  "updateTime" : 1725270088699,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "selectColumnFromTable",
  "method" : "GET",
  "parameters" : [ {
    "name" : "tableName",
    "value" : "NDMP_MIB",
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": [\n        {\n            \"columnName\": \"ID\",\n            \"columnComment\": \"ID\"\n        },\n        {\n            \"columnName\": \"INTERNAL\",\n            \"columnComment\": \"INTERNAL\"\n        },\n        {\n            \"columnName\": \"ALIAS\",\n            \"columnComment\": \"ALIAS\"\n        },\n        {\n            \"columnName\": \"NAME\",\n            \"columnComment\": \"NAME\"\n        },\n        {\n            \"columnName\": \"OID\",\n            \"columnComment\": \"OID\"\n        },\n        {\n            \"columnName\": \"PARENT_OID\",\n            \"columnComment\": \"PARENT_OID\"\n        },\n        {\n            \"columnName\": \"BASE_TYPE\",\n            \"columnComment\": \"BASE_TYPE\"\n        },\n        {\n            \"columnName\": \"STATUS\",\n            \"columnComment\": \"STATUS\"\n        },\n        {\n            \"columnName\": \"ACCESS\",\n            \"columnComment\": \"ACCESS\"\n        },\n        {\n            \"columnName\": \"KIND\",\n            \"columnComment\": \"KIND\"\n        },\n        {\n            \"columnName\": \"MODULE\",\n            \"columnComment\": \"MODULE\"\n        },\n        {\n            \"columnName\": \"DESCRIPTION\",\n            \"columnComment\": \"DESCRIPTION\"\n        },\n        {\n            \"columnName\": \"CLASSIFICATION\",\n            \"columnComment\": \"CLASSIFICATION\"\n        }\n    ]\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : null,
    "value" : null,
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  },
  "responseBodyDefinition" : {
    "name" : null,
    "value" : null,
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }
}
================================
return  db.select("""
 SELECT COLUMN_NAME, COLUMN_NAME COLUMN_COMMENT FROM  all_tab_COLUMNS
            where owNer='NDMP'
         AND TABLE_NAME= UPPER(#{tableName})

""")